<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateEsoContract extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('eso_contract', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('eso_contact_name',128)->comment('姓名');
            $table->string('eso_contact_hope_class',128)->comment('希望班级');
            $table->string('eso_contact_hope_school',128)->comment('希望学校');
            $table->string('eso_contact_email',128)->comment('邮件');
            $table->integer('eso_contact_free_class')->default('0')->comment('免费课');
            $table->integer('eso_contact_test_flag')->default('0')->comment('入学测试');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('eso_contract');
    }
}
